Power to Win

KB1039 - Excel Reports

Overview

The analysis application allows user reports to be generated that are exported directly to microsoft excel. A report may consist of up to 32 channels (including math channels) with different methods defined for each channel. There are 5 different report types currently available.

After a report has been defined clicking on the "excel reports" menu will automatically open a new excel spreadsheet and export the report data. Any changes made to loaded outings or laps will automatically refresh the report data.

A typical report may contain information such as maximum and/or minimum engine rpm around the track, entry and exit speeds at track segments and engine operating temperatures or pressures. Any channel can be used for a report with 8 different report methods to choose from.

Report Setup

Use this function to create and setup your excel reports.

1. On the Reports menu, click Setup.
2. The report editor window will be displayed.
3. Click on the Reports tab.

   A list of the currently defined reports will be displayed. You can click on the "new" icon to add a new report or the "edit" icon to edit an existing report. The report channel editor window will be displayed listing the channels for the current report.

4. Enter a user name for this report.
5. Select the report type from the drop down combo box.
6. Click Add to add a new channel to the report.
7. Select the channel and method you require.
8. Click OK to save changes.

After you have defined your reports you can use the Excel Reports menu to open a new excel document and display your reports.

Report Types

• Lap - returns data at each defined split for every lap.
• Global - returns channel report data for the entire outing.
• Split - compares each lap with the loaded datum, returns the segment difference and also the best and rolling lap times.
• Event - returns where and when a specific event occured.
• Graphic - graphical report overlaid on the current track map.

Report Methods

• Maximum (returns the maximum value for the segment)
• Minimum
• Average
• Entry (returns values for the entry point of the track segment)
• Exit
• Delta (difference between the entry and exit values)
• At Same (the value for the channel at the previous defined channel method)
• Middle (returns values from the middle of a track segment)

Notes

• Microsoft excel 2000 or higher must be installed to use the report function.
• Only the graphic report will allow the "where" field to be edited.
• Replacing an outing will automatically update the report sheet.

Winning Edge Electronics

(c) 2014 EFI Technology Inc. All Rights Reserved.